:Base odbcjet.hlp
:Title ODBC Microsoft Desktop Database Drivers Help
:Index ODBC Desktop Database Drivers Help=odbcjet.hlp
1 For All Users
2 Overview=Overview>concard
2 Hardware and Software Requirements=Requirements>concard
2 ODBC Component Files=ODBCComponentFiles>concard
2 Product Support=ProductSupport>concard
2 Setting Up Drivers=SettingUpDrivers>concard
2 Adding, Modifying, or Deleting a Data Source
3 Adding a Data Source=AddingADataSource>procard
3 Adding a System Data Source=AddingASystemDataSource>procard
3 Data Source Conversion=DataSourceConversion>concard
3 Modifying a Data Source=ModifyingADataSource>procard
3 Deleting a Data Source=DeletingADataSource>procard
3 Adding, Modifying, or Deleting a Data Source Dynamically=AddingModifyingOrDeletingADataSourceDynamically>procard
3 Text Format
4 Defining Text Format=TextFormat>concard
4 SCHEMA.INI=SchemaIni>concard
3 ODBC Setup Dialog Box
4 Approximate Row Count=ApproximateRowCount>concard
4 Buffer Size=BufferSize>concard
4 Collating Sequence=CollatingSequence>concard
4 Data Source Name=DataSourceName>concard
4 Database=Database>concard
4 Define Format=DefineFormat>concard
4 Description=Description>concard
4 Directory=Directory>concard
4 Exclusive=Exclusive>concard
4 Extensions List=ExtensionsList>concard
4 Network Directory=NetworkDirectory>concard
4 Page Timeout=PageTimeout>concard
4 Read Only=ReadOnly>concard
4 Rows to Scan=RowsToScan>concard
4 Select Directory=SelectDirectory>concard
4 Select Indexes=SelectIndexes>concard
4 Show Deleted Rows=ShowDeletedRows>concard
4 Sort Order=SortOrder>concard
4 System Database=SystemDatabase>concard
4 Use Current Directory=UseCurrentDirectory>concard
4 User Name=UserName>concard
4 Version=Version>concard
4 Workbook=Workbook>concard
2 Connecting to a Data Source
3 Password Entry=PasswordEntry>concard
3 Heterogeneous Joins/Attached Tables=HeterogeneousJoinsAttachedTables>concard
3 Opening Microsoft Excel Tables=OpeningMicrosoftExcelTables>concard
3 Password-Protected Files=PasswordProtectedFiles>concard
3 Referential Integrity=ReferentialIntegrity>concard
3 Lotus 123 Data/EMS Data=Lotus123DataEMSData>concard
3 Visual Basic Support=VisualBasicSupport>concard
1 For Advanced Users
2 Connection Strings=ConnectString>concard
2 Error Messages=Errors>concard
2 Database Repair=DatabaseRepair>concard
2 Database Compaction=DatabaseCompaction>concard
2 SQL Statements
3 Additional Supported ODBC SQL Grammar=Add_Grammar>concard
3 Driver-Specific SQL Grammar
4 BETWEEN Predicate=BETWEENPredicate>concard
4 COUNT (expression)=COUNTExpression>concard
4 CREATE INDEX Statement=CREATEINDEXStatement>concard
4 Date Arithmetic=DateArithmetic>concard
4 Date Literals=DateLiterals>concard
4 DROP INDEX Statement=DROPINDEXStatement>concard
4 Fixed-Width Text File=FixedWidthTextFile>concard
4 GROUP BY expression-list=GROUPBYExpressionList>concard
4 ORDER BY expression-list=ORDERBYExpressionList>concard
4 ORDER BY with GROUP BY=ORDERBYWithGROUPBY>concard
4 Outer Joins=OuterJoins>concard
4 Scalar Functions=ScalarFunctions>concard
4 Table Names=TableNames>concard
3 Limitations to SQL Grammar
4 Aggregate Functions Limitations=AggregateFunctionsLimitations>concard
4 ALTER TABLE Statement Limitations=ALTERTABLEStatementLimitations>concard
4 AND Predicate Limitations=ANDPredicatesLimitations>concard
4 CALL Statement Limitations=CALLStatementLimitations>concard
4 Column Name Limitations=ColumnNameLimitations>concard
4 CONVERT Function Limitations=CONVERTFunctionLimitations>concard
4 CREATE INDEX Statement Limitations=CREATEINDEXStatementLimitations>concard
4 CREATE TABLE Statement Limitations=CREATETABLEStatementLimitations>concard
4 Date Arithmetic Limitations=DateArithmeticLimitations>concard
4 DELETE Statement Limitations=DELETEStatementLimitations>concard
4 DISTINCT Keyword Limitations=DISTINCTKeywordLimitations>concard
4 DROP TABLE Statement Limitations=DROPTABLEStatementLimitations>concard
4 FROM Clause Limitations=FROMClauseLimitations>concard
4 HAVING Clause Limitations=HAVINGClauseLimitations>concard
4 Identifiers Limitations=IdentifiersLimitations>concard
4 Index Name Limitations=IndexNameLimitations>concard
4 INSERT Statement Limitations=INSERTStatementLimitations>concard
4 LIKE Predicate Limitations=LIKEPredicateLimitations>concard
4 NOT NULL Limitations=NOTNULLLimitations>concard
4 ORDER BY Clause Limitations=ORDERBYClauseLimitations>concard
4 Parameterized Query Limitations=ParameterizedQueryLimitations>concard
4 Reserved Word Limitations=ReservedWordLimitations>concard
4 Scalar Function Limitations=ScalarFunctionLimitations>concard
4 SELECT DISTINCT Limitations=SELECTDISTINCTLimitations>concard
4 SELECT Statement Limitations=SELECTStatementLimitations>concard
4 Set Functions Limitations=SetFunctionsLimitations>concard
4 Sorting Limitations=SortingLimitations>concard
4 String Limitations=StringLimitations>concard
4 Table Name Limitations=TableNameLimitations>concard
4 Table References Limitations=TableReferencesLimitations>concard
4 UPDATE Statement Limitations=UPDATEStatementLimitations>concard
4 Views Limitations=ViewsLimitations>concard
4 WHERE Clause Limitations=WHEREClauseLimitations>concard
4 WHERE CURRENT OF Clause Limitations=WHERECURRENTOFClauseLimitations>concard
2 Data Types
3 Microsoft Access=AccessDataTypes>concard
3 dBASE=dBASEDataTypes>concard
3 Microsoft Excel=ExcelDataTypes>concard
3 Microsoft FoxPro=FoxProDataTypes>concard
3 Paradox=ParadoxDataTypes>concard
3 Text=TextDataTypes>concard
3 Data Type Limitations=DataTypeLimit>concard
1 For Programmers
2 SQLGetInfo Returned Values=SQLGetInfoReturnValues>concard
2 ODBC API Functions
3 Supported ODBC API Functions=SupportedODBCAPIFunctions>concard
3 SQLColAttributes=SQLColAttributes>concard
3 SQLColumns=SQLColumns>concard
3 SQLConfigDataSource=SQLConfigDataSource>concard
3 SQLConnect=SQLConnect>concard
3 SQLDriverConnect=SQLDriverConnect>concard
3 SQLGetData=SQLGetData>concard
3 SQLGetInfo=SQLGetInfo>concard
3 SQLGetTypeInfo=SQLGetTypeInfo>concard
3 SQLMoreResults=SQLMoreResults>concard
3 SQLPrepare=SQLPrepare>concard
3 SQLProcedureColumns=SQLProcedureColumns>concard
3 SQLProcedures=SQLProcedures>concard
3 SQLSetConnectOption=SQLSetConnectOption>concard
3 SQLSetCursorName=SQLSetCursorName>concard
3 SQLSetPos=SQLSetPos>concard
3 SQLSetScrollOptions=SQLSetScrollOptions>concard
3 SQLSetStmtOption=SQLSetStmtOption>concard
3 SQLSpecialColumns=SQLSpecialColumns>concard
3 SQLStatistics=SQLStatistics>concard
3 SQLTables=SQLTables>concard
3 SQLTransact=SQLTransact>concard
2 Implementation Issues
3 Arithmetic Errors=ArithmeticErrors>concard
3 Base Address of Drivers=BaseAddressOfDrivers>concard
3 Creating and Opening Tables=CreatingAndOpeningTables>concard
3 Multiple hstmts=MultipleHstmts>concard
3 Read-Only Status=ReadOnlyStatus>concard
3 Setup DLL=SetupDLL>concard
3 Single-User Mode Versus Multi-User Mode=SingleUserModeVersusMultiUserMode>concard
3 Translation DLLs=TranslationDLLs>concard